How to: Switch between Design view and Datasheet view.
Solution:
To switch between Design view and Datasheet view, when in one view, select the 'View' menu and select the other view.
1) When in Design view, select the 'View' menu and select 'Datasheet'. (A dot appears next to Datasheet on the View menu, and the Datasheet view opens.)
2) When in Datasheet view, select the 'View' menu and select '<object> Design', where <object> is Table, Query, or Form. (A dot appears next to Design on the View menu and the Design view opens.)